Copyright: Copyright © Corel Corporation Limited. 1996, 1997.   Wed Jul 30 15:10:26 1997. All Rights Reserved.
Citation: Copyright © Corel Corporation Limited. 1996, 1997. All Rights Reserved.


Format Area

When you join and center a title, Corel Quattro Pro joins the cells that you select into one cell.

1	To unjoin cells, right-click the joined cell.

2	Click Cell Properties [image] Alignment, then deselect Join Cells.

When you insert areas for addresses, messages, and so on, Corel Quattro Pro creates a text box which you can move and size anywhere in the notebook. For information about moving and sizing text boxes, click [image].

When you insert a signature line, Corel Quattro Pro enters the information at the insertion point. Information wider than the current cell overlaps empty adjoining cells.

Tips

You can also quickly join cells and center text using the toolbar. Select cells, then click [image] on the toolbar.

To turn off the grid lines that display on your screen, right-click the tab at the bottom of the notebook sheet, click Sheet Properties, then deselect Horizontal and Vertical grid lines.

Related Concepts


Typing in Cells

When you type text in a notebook, you type information into cells.  Corel Quattro Pro evaluates what you type and classifies it as either a label or a value.

A label is text alone or text with numbers. A value is a number, date, or formula. For example, phone numbers and addresses are labels. Corel Quattro Pro formats labels differently than values.

1	Click where you want to type or replace text.

2	Begin typing, then press Enter, Tab, or arrow keys when you finish.

For more information about moving data, click [image].

Tips

To cancel changes before you press Enter, press Esc.

To delete cell contents, click the cell, then type new data or press Del.

To delete cell contents and formatting, select the cells, right-click the cells, then click Clear.

To delete part of a cell's contents, double-click the cell, click to place the insertion point, then press Backspace or Del.

To restore an accidental deletion, click Edit [image] Undo.

If you type a symbol such as +-$,(@.# or =, Corel Quattro Pro detects the information as a formula or value. (This includes the currency symbol from your default language setting.) If you want the information to be a label, you must first type ". For example, to enter (Before Taxes), type: "(Before Taxes).

Related Concepts


Work with Data

Tips

Use Sort when you want to sort a single column or row. Use QuickFilter when you want to sort rows by the items in a particular column. For example, say you have many columns of data and you want to keep the data with the names in the first column. Use QuickFilter to sort by names in the first column and have data in the other columns remain with the correct name.

It doesn't take an expert to use the Budget or Analysis Expert. Try these options when you want Corel Quattro Pro to set up the notebook for you from the data you provide.

Use the Formula Composer when you are familiar with math formulas and @functions, but you need help assembling the correct syntax.

Related Concepts


Finish

Tips

If you have set up a complicated form for your data, you may want to reuse the form without the current data. To do this, first save your current file. Select the cells you want to clear, then click Clear Values. Click Save Notebook and save the form under a different file name.

If you want to preview your file before you print, click File [image] Print Preview. From Print Preview, you can also adjust page margins and setup, and then print your notebook.

Use the Save Notebook option on the PerfectExpert to save your file, or click File [image] Save. It is a good idea to save your file frequently as you work. For example, click Save before spell checking or printing your file.


Size and Move Text Boxes

A text box is like a graphic. It exists above the notebook and can be moved and sized where you want.

1	To move the text box, click the border to select it, then drag the border to move the box to a new location.

2	To size the text box, click the border, then drag a sizing handle to change the size.

3	Drag a corner handle to size in two directions at once.

Tips

If you are typing in a text box, click outside the text box, then click the text box border to select the box.

Related Concepts


Quick Math

Quick Math inserts a formula for you when you want to do math on a single row or column of figures. For example, you could add a column, find the average of a list of figures, or find the middle value.

The advantage of using a formula is that you can change values in the list and the formula automatically updates the answer to reflect the changes.

1	To select a row or column for Quick Math, click the selection arrow, then drag to select the figures.

2	Click the square button on the Quick Math title bar to restore the dialog.

3	Select a math operation from the Do Math drop down list.

4	Click the selection arrow to select an answer cell, then click the cell where you want the answer.

5	Click the square button on the Quick Math title bar, then click OK to enter the formula.

Tips

You can also type cell references in the appropriate text boxes to specify rows, columns, and answer cells.

To work faster, select the row or column before clicking Quick Math.

When you use a selection arrow to select cells, the current dialog minimizes so that only the title bar displays. To restore the dialog, you need to click the square (maximize) button.

Related Concepts


More Quick Math

More Quick Math inserts formulas for you when you want to do math on each item in a row or column. For example, you could find 60% of each item in a retail price list to arrive at a wholesale price.

The advantage of using a formula is that you can change values in the retail list and the formula automatically updates the answers to reflect changes.

1	To select a row or column, click the selection arrow, then drag to select the figures.

2	Click the square button on the More Quick Math title bar to restore the dialog.

3	Select a math operation from the Do Math drop down list, then specify an amount if needed.

4	Click the selection arrow to select an answer location, then drag to select a row or column. The answer row or column must be the same size as the list of figures.

5	Click the square button on the More Quick Math title bar, then click OK to enter the formula.

Tips

You can also type cell references in the appropriate text boxes to specify rows, columns, and answer cells.

To work faster, select the row or column before clicking More Quick Math.

When you use a selection arrow to select cells, the current dialog minimizes so that only the title bar displays. To restore the dialog, you need to click the square (maximize) button.

Related Concepts


Two-Column Quick Math

Two-Column Quick Math inserts formulas for you when you want to do math between rows or columns, such as multiply each item in one column with each item in another column. For example, you could multiply a quantity column by the unit price column to find the total cost (5 units x $5.00 each = $25.00).

The advantage of using a formula is that you can change values in either list and the formula automatically updates the answers to reflect changes.

1	To select the first row or column, click the selection arrow, then drag to select the figures.

2	Click the square button on the Two-Column Quick Math title bar to restore the dialog.

3	Repeat steps 1-2 for the second row or column.

4	Select a math operation from the Do Math drop down list, then specify an amount if needed.

5	Click the selection arrow to select an answer location, then drag to select a row or column. The answer row or column must be the same size as the list of figures.

6	Click the square button on the Two-Column Quick Math title bar, then click OK to enter the formulas.

Tips

You can also type cell references in the appropriate text boxes to specify rows, columns, and answer cells.

To work faster, select the first row or column before clicking 2-Column Quick Math.

When you use a selection arrow to select cells, the current dialog minimizes so that only the title bar displays. To restore the dialog, you need to click the square (maximize) button.

Related Concepts